CustomerMembershipProgramAccount

Entity Definition

Logical Name : CustomerMembershipProgramAccount
Physical Name : LE_CT_MBRSHP_PRGM_ACNT

This is an optional entity type that allows a retailer to associate multiple CustomerMembershipPrograms with a single CustomerMembershipAccount. This allows consolidated reporting of customer activities related to different membership programs. An example of this is customer A (with a membership account A1) is enrolled in two retailer clubs. The first is the Auto club which offers special rewards tied to the purchase of fuel, oil, auto parts and tires. The second is the Food Club which offers special rewards tied to the purchase of groceries. Both club memberships can be tied to a single CustomerMembershipAccount. Grocery retailers sometimes offer customers a menu of different "clubs" that may offer combined and separate rewards.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
CustomerMembeshiprProgramAccountID (PK) Token ID for a CustomerMemberProgramAccount. ID_CT_MBR_PRGM_ACNT Identity integer
CustomerAccountID (FK) A unique identifier for a customer account. ID_CTAC Identity integer CustomerMembershipAccount(LE_CT_MBRSHP_ACNT)
EffectiveDate Date a CustomerRewardAccount becomes active. DC_EF_DT EffectiveDate date
ExpirationDate Date a CustomerRewardProgramAccount becomes inactive DC_EP_DT ExpirationDate date
StatusCode Current status of this CustomerRewardProgramAccount Valid values are A Active I Inactive CD_STS Code2Status char(2)
MembershipProgramID (FK) Token ID for a CustomerRewardProgram instance. ID_CT_MBRSHP_PRGM Identity integer CustomerMembershipProgramLevel(CO_CT_MBRSHP_PRGM_LV)
LevelNumber (FK) A whole number that establishes the relative value of a membership program level. The higher the value, the greater the level and its associated rewards and, where applicable, fees. IC_LV_NMB Number integer CustomerMembershipProgramLevel(CO_CT_MBRSHP_PRGM_LV)

Relationships

Parent Entity Verb Phrase Child Entity
CustomerMembershipAccount is enrolled in CustomerMembershipProgramAccount
CustomerMembershipProgramLevel enrolls CustomerMembershipProgramAccount
CustomerMembershipProgramAccount defines basis for CustomerReward
CustomerMembershipProgramAccount Z_CustomerMembershipProgramAccountLedger
CustomerMembershipProgramAccount is valued based on CustomerAccountRewardTierStatus

Logical Views containing CustomerMembershipProgramAccount

Logical View
Logical 01400 - Item Rewards Derivation - Transaction Level
Logical 07010 - Customer Account Information Extended